Skip to main content

Following steps to create dataset using External Datasource

  • From this document, you will learn to create a dataset in OPNBI, Also you will learn to make a dataset using External Data Sources.

What is External Dataset?​

  • datasets are populated by LiveCompare actions where the results are stored as External Data Sources. User can use this dataset when they want live data.

  • Examples of traditional external data may include information from statistics departments, third-party market research databases, official press releases, etc. ...

Prerequisite​

  • User need a API with CSV or JSON extension from which user like to pull the data.

  • There are two supported FileType:- CSV & JSON

  1. Click on hamburger icon.

  2. In Master Data Tab click on Dataset.

    Docusaurus Slash Introduction

  3. Click on create dataset, As shown in figure below:

    Docusaurus Slash Introduction

  4. Enter following details in Create Dataset.

info

We are using unpaid API for this example. It is necessary that the API URL should be CSV Type for this example.

  • There are two types of request:-

1. GET: GET request is usually used to get existing data or to retrieve data for an entity set.
2. POST: POST request is usually used to create a new object in the system and obtain information about it.

info

Follow this Link to know more APIs.

  1. Fill above details, As shown in figure below:

    Docusaurus Slash Introduction

info

POST Request type will releases in subsequent releases.

  1. Click on Preview and submit button.

  2. You will see the External Dataset, As shown in figure below:

    Docusaurus Slash Introduction

  3. Click on visualization Tab and open Dashboard.

  4. From Right Vertical Menu Select the Table Widget icon.

  5. The Edit menu box appears as you click Table Widget icon. And a widget gets added in content place automatically in dashboard.

  6. Enter Following Details in edit box, As shown in figure below:

  • Dataset: External.ds
  • Select all the Field in Dataset Column.

  1. Fill above details, As shown in figure below:

    Docusaurus Slash Introduction

  2. Click on Preview and Save and Exit.

  3. Now, match your Table Widget with the below example, it should look like the figure below:

    Docusaurus Slash Introduction

Dataset from CSV​

Dataset from EXCEL​

Dataset from JSON​

Dataset from Flatfiles​

info

JSON Filetype & POST Request type will releases in subsequent releases.

To know more about how to create dataset using different sources follow below Links:-

Dataset using CSV​

Dataset using JSON​

Dataset using Flatfiles​

Dataset using Excel​

Dataset using Google BigQuery​

Dataset using noSQL ​

Dataset using Join​

Dataset using Union​

Dataset using Server Script​

Dataset using Client Script​

Dataset using Stored Procedure​

Dataset using View​

Dataset using Simple Query​

Dataset using Drag & Drop​